package org.jeecg.modules.demo.ch.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.demo.ch.entity.WeeklyReportFeedback;

import java.util.List;

/**
 * @Description: 周报反馈系统
 * @Author: jeecg-boot
 * @Date:   2022-11-14
 * @Version: V1.0
 */
public interface WeeklyReportFeedbackMapper extends BaseMapper<WeeklyReportFeedback> {

    /**
     * 根据执行人  执行状态 时间段进行分页查询
     * @param pageNo
     * @param pageSize
     * @param executor
     * @param executionStatus
     * @param beginTime
     * @param endTime
     * @return
     */
    List<WeeklyReportFeedback> selectChWeeklyReportFeedbackListByTime(@Param("pageNo") Integer pageNo,@Param("pageSize") Integer pageSize,@Param("executor") String executor,@Param("executionStatus") String executionStatus,@Param("classification") String classification,@Param("weeklyMeetTitle") String weeklyMeetTitle,@Param("representation") String representation,@Param("beginTime") String beginTime,@Param("endTime") String endTime,@Param("permissionSql") String permissionSql);

    /**
     * 根据执行人  执行状态 时间段进行查询总条数
     * @param executor
     * @param executionStatus
     * @param beginTime
     * @param endTime
     * @return
     */
    int selectChWeeklyReportFeedbackListTotalByTime(@Param("executor") String executor,@Param("executionStatus") String executionStatus,@Param("classification") String classification,@Param("weeklyMeetTitle") String weeklyMeetTitle,@Param("representation") String representation, @Param("beginTime") String beginTime,@Param("endTime") String endTime,@Param("permissionSql") String permissionSql);

    /**
     * 根据时间段进行查询未完成的
     * @param beginTime
     * @param endTime
     * @return
     */
    List<WeeklyReportFeedback> selectChWeeklyReportFeedbackListForLastWeek(@Param("beginTime") String beginTime,@Param("endTime")  String endTime);
}
